
             
/**
 * 
 *
 * Copyright (c) 2012-2013 JLLT Corp. 2012-2013,All Rights Reserved.
 * This software is published under the 金麟龙腾商贸有限公司.
 * License version 1.0, a copy of which has been included with this
 * distribution in the LICENSE.txt file. 
 *
 * @File name:  TProductDao.java 
 * @Create on:  2012-06-28 21:05:412
 * @Author      :  高宇舟
 *
 * @ChangeList
 * ---------------------------------------------------
 * Date         Editor              ChangeReasons
 *
 */
           
        package com.boho.ecp.product.dao;

            
import java.sql.Connection;
import java.util.List;

import cn.boho.framework.po.CQExp;
import cn.boho.framework.po.DAO;
            
        /**
 * 【板块商品信息:T_PLATE_PRODUCT】的Dao操作类
 * 
 */
public class TPlateProductDao extends DAO {
	
	/**
	* 根据条件查询【板块商品信息:T_PLATE_PRODUCT|】信息
	* @param con
	* @param plateCode 板块代码
	* @param isValid 是否有效
	* @return
	* @throws Exception
	* @date2012-07-18
	* @author 高宇舟
	* 
	*/
	public static List queryTPlateProduct(Connection con,java.lang.String plateCode,java.lang.Integer isValid)throws Exception{
		CQExp cqExp = CQExp.instance().select("select T_PLATE_PRODUCT.PLATE_DESC,T_PLATE_PRODUCT.PLATE_PRODUCTS,T_PLATE_PRODUCT.PLATE_CODE,T_PLATE_PRODUCT.PLATE_ID,T_PLATE_PRODUCT.PLATE_TAG from T_PLATE_PRODUCT ")
			.where()
			.filed("T_PLATE_PRODUCT.IS_VALID",CQExp.EQ,isValid)
			.filed(plateCode == null || plateCode.equals("") ? null:"T_PLATE_PRODUCT.PLATE_CODE",CQExp.EQ,plateCode)
			;
		System.out.println(cqExp.getSql());
		return cqExp.getDynaBeanMapList("T_PLATE_PRODUCT",con);
	}
}
